The SQL DELETE statement enables you to identify ( or restrict) the rows you want to delete through a WHERE clause. SQLDELETE语句允许通过WHERE子句识别(或限制)要删除的行。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax. 但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的SQL语法操作第三方服务上的数据。
You could use the DELETE SPARQL statement with a WHERE clause to find the data by name rather than URI, which would enable you to have an identical function header to the SQL version. 您可以将DELETESPARQL语句与WHERE子句结合使用以按名称而不是按URI查找数据,这将拥有与SQL版本相同的函数头。
The SQL standard does not provide a way to insert/ update/ delete multiple tables in a single statement, so applications need to execute two separate statements, one for each table. SQL标准不支持在一条语句中对多个表执行插入/更新/删除操作,所以应用程序需要执行两条不同的语句,对每个表执行一条语句。
For example, let's say you chose a Time to trigger action of Before for an trigger that is fired by a DELETE statement. 例如,假设您的触发器选择的Timetotriggeraction是Before,触发事件是DELETE语句。
The first data modification technique discussed was data deletion, which is performed by using the SQL DELETE statement. 讨论的第一种数据修改技术是数据删除,这通过使用SQLDELETE语句来执行。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them. 在某种程度上,SQLUPDATE语句是SQLINSERT和DELETE语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
In this case, they can issue a SELECT statement to identify rows that qualify then DELETE those rows. 在这种情况下,他们可以发出一条SELECT语句来识别符合条件的行,然后再DELETE那些行。
If the correction is to delete the problematic row data, delete the row using the BEGIN WORK WITHOUT REPLICATION statement. 如果更正措施是删除有问题的行数据,那么使用BEGINWORKWITHOUTREPLICATION语句删除行。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES. 存储过程中的第一个语句是DELETE,它删除本地目标表SALES中现有的行。
DB2 sets the end time of the deleted row in the history table to the start time that is associated with the most recent transaction of the DELETE statement. DB2将历史表中所删除行的结束时间设置为与DELETE语句的最新事务相关联的开始时间。
And that is what the DELETE statement is doing. 而这就是DELETE语句所进行的工作。
The DELETE statement deletes all rows from the specified table that satisfy an optional WHERE clause. DELETE语句从指定表中删除满足可选WHERE子句的所有行。
Instead, you would need to create another preparedStatement for the delete, and another message would be sent to the database server to prepare the statement for the delete query. 而是需要另外创建一个preparedStatement来执行删除操作,且另外会有一条消息被发送到数据库服务器来准备删除查询语句。
The OLD TABLE transition table holds the original state of the affected rows before they are processed by the UPDATE or DELETE statement. OLDTABLE过渡表保存了受影响的行在被UPDATE或DELETE语句处理之前的初始状态。
After the execution of the UPDATE, INSERT, and DELETE statements, an additional variable is available to check the result of the statement. 执行完UPDATE、INSERT和DELETE语句后,将使用额外的一个变量来检查语句的结果。
Delete data in the existing table that matches the row filter statement 删除已存在的表中与过滤语句匹配的数据
For tables with one or more of these characteristics, use the delete statement instead. 对于具有以上一个或多个特征的表,请使用delete语句。
Registered custom stored procedure is executed when a delete statement is replicated. 复制delete语句时,将执行注册的自定义存储过程。
Data was changed by a delete statement. 数据已由delete语句更改。
Observe the delete statement that has replaced the drop statement. 请观察取代drop语句的delete语句。
If no where clause appears, the delete statement remove all rows in the table. 如果未出现任何where子句,则delete语句将删除表中所有的行。
The DELETE statement is used to delete rows in a table. DELETE声明常用来删除表中的数据。
Filter the data to be included in this publication. Delete data in the existing object that matches the row filter statement 筛选出将要包含在该发布内容中的数据。删除现有对象中与行筛选语句相匹配的数据
To replace data in a table, the delete statement must be used to clear existing data before loading new data with insert. 若要替换表中的数据,在使用insert加载新数据之前,必须使用delete语句清除现有的数据。
After a delete statement is executed, the table can still contain empty pages. 执行delete语句后,表仍会包含空页。
When you select this option, the wizard will attempt to generate insert, update, and delete statements based on the select statement defined on the generate SQL statements page. 选择此选项时,向导将根据在“生成sql语句”页上定义的select语句尝试生成insert、update和delete语句。